Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 278587 |
| Missing cells | 24663 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 65.9 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Text | 13 |
| DateTime | 3 |
| Categorical | 6 |
| Unsupported | 2 |
ACCESSORIAL_AMOUNT is highly overall correlated with ACCESSORIAL_CHARGE_AMOUNT and 1 other fields | High correlation |
ACCESSORIAL_CHARGE_AMOUNT is highly overall correlated with ACCESSORIAL_AMOUNT and 1 other fields | High correlation |
AMOUNT_PAID is highly overall correlated with ACCESSORIAL_AMOUNT and 1 other fields | High correlation |
BILL_TYPE is highly overall correlated with SHIP_WEIGHT and 1 other fields | High correlation |
IO_CODE is highly overall correlated with IO_CODE_DESCRIPTION and 1 other fields | High correlation |
IO_CODE_DESCRIPTION is highly overall correlated with IO_CODE and 1 other fields | High correlation |
SHIP_WEIGHT is highly overall correlated with BILL_TYPE | High correlation |
SOLAR_MODE is highly overall correlated with BILL_TYPE | High correlation |
Unnamed: 0 is highly overall correlated with IO_CODE and 1 other fields | High correlation |
BILL_TYPE is highly imbalanced (52.3%) | Imbalance |
SHIPPER_NAME is highly imbalanced (58.1%) | Imbalance |
DESTINATION_COUNTRY_CODE has 2813 (1.0%) missing values | Missing |
DESTINATION_STATE has 3286 (1.2%) missing values | Missing |
ORIGIN_STATE has 6996 (2.5%) missing values | Missing |
PRO_NUMBER2 has 9317 (3.3%) missing values | Missing |
ACCESSORIAL_AMOUNT is highly skewed (γ1 = 41.83294079) | Skewed |
ACCESSORIAL_CHARGE_AMOUNT is highly skewed (γ1 = 22.23821765) | Skewed |
AMOUNT_PAID is highly skewed (γ1 = 26.05638454) | Skewed |
SHIP_WEIGHT is highly skewed (γ1 = 25.84201104) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
DESTINATION_ZIP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ORIGIN_ZIP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MILEAGE has 128368 (46.1%) zeros | Zeros |
SHIP_WEIGHT has 51581 (18.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-16 06:34:07.856772 |
|---|---|
| Analysis finished | 2024-02-16 06:34:49.584754 |
| Duration | 41.73 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
HIGH CORRELATION  UNIFORM  UNIQUE 
| Distinct | 278587 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 139293 |
| Minimum | 0 |
|---|---|
| Maximum | 278586 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13929.3 |
| Q1 | 69646.5 |
| median | 139293 |
| Q3 | 208939.5 |
| 95-th percentile | 264656.7 |
| Maximum | 278586 |
| Range | 278586 |
| Interquartile range (IQR) | 139293 |
Descriptive statistics
| Standard deviation | 80421.284 |
|---|---|
| Coefficient of variation (CV) | 0.57735338 |
| Kurtosis | -1.2 |
| Mean | 139293 |
| Median Absolute Deviation (MAD) | 69647 |
| Skewness | 1.1307088 × 10-15 |
| Sum | 3.8805219 × 1010 |
| Variance | 6.4675829 × 109 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 185722 | 1 | < 0.1% |
| 185728 | 1 | < 0.1% |
| 185727 | 1 | < 0.1% |
| 185726 | 1 | < 0.1% |
| 185725 | 1 | < 0.1% |
| 185724 | 1 | < 0.1% |
| 185723 | 1 | < 0.1% |
| 185721 | 1 | < 0.1% |
| 187175 | 1 | < 0.1% |
| Other values (278577) | 278577 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 278586 | 1 | |
| 278585 | 1 | |
| 278584 | 1 | |
| 278583 | 1 | |
| 278582 | 1 | |
| 278581 | 1 | |
| 278580 | 1 | |
| 278579 | 1 | |
| 278578 | 1 | |
| 278577 | 1 |
ACCESSORIAL_AMOUNT
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 41989 |
|---|---|
| Distinct (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1758.7773 |
| Minimum | 0.01314 |
|---|---|
| Maximum | 896151.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 0.01314 |
|---|---|
| 5-th percentile | 15.5052 |
| Q1 | 52.56 |
| median | 233.09046 |
| Q3 | 917.64504 |
| 95-th percentile | 6718.3243 |
| Maximum | 896151.99 |
| Range | 896151.98 |
| Interquartile range (IQR) | 865.08504 |
Descriptive statistics
| Standard deviation | 13026.212 |
|---|---|
| Coefficient of variation (CV) | 7.4064019 |
| Kurtosis | 2312.6202 |
| Mean | 1758.7773 |
| Median Absolute Deviation (MAD) | 209.33334 |
| Skewness | 41.832941 |
| Sum | 4.8997249 × 108 |
| Variance | 1.6968219 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 68.328 | 6096 | 2.2% |
| 91.98 | 1361 | 0.5% |
| 65.7 | 859 | 0.3% |
| 51.7716 | 820 | 0.3% |
| 64.55682 | 721 | 0.3% |
| 785.6406 | 645 | 0.2% |
| 328.5 | 441 | 0.2% |
| 52.56 | 412 | 0.1% |
| 131.4 | 406 | 0.1% |
| 459.9 | 385 | 0.1% |
| Other values (41979) | 266441 |
| Value | Count | Frequency (%) |
| 0.01314 | 2 | |
| 0.07884 | 1 | < 0.1% |
| 1.0512 | 1 | < 0.1% |
| 1.15632 | 1 | < 0.1% |
| 1.26144 | 3 | |
| 1.314 | 2 | |
| 1.52424 | 1 | < 0.1% |
| 1.53738 | 1 | < 0.1% |
| 1.5768 | 1 | < 0.1% |
| 1.6425 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 896151.9946 | 12 | |
| 846140.4319 | 12 | |
| 655493.9589 | 8 | |
| 592760.6161 | 6 | |
| 563688.5107 | 8 | |
| 533514.695 | 6 | |
| 448882.9772 | 12 | |
| 419682.4677 | 5 | |
| 392183.01 | 11 | |
| 353885.4945 | 4 | < 0.1% |
ACCESSORIAL_CHARGE_AMOUNT
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 42057 |
|---|---|
| Distinct (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 472.41597 |
| Minimum | 0.01314 |
|---|---|
| Maximum | 129950.04 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 0.01314 |
|---|---|
| 5-th percentile | 11.79972 |
| Q1 | 23.54688 |
| median | 51.41682 |
| Q3 | 166.10931 |
| 95-th percentile | 1422.3748 |
| Maximum | 129950.04 |
| Range | 129950.03 |
| Interquartile range (IQR) | 142.56243 |
Descriptive statistics
| Standard deviation | 3259.0799 |
|---|---|
| Coefficient of variation (CV) | 6.8987506 |
| Kurtosis | 622.73217 |
| Mean | 472.41597 |
| Median Absolute Deviation (MAD) | 35.64882 |
| Skewness | 22.238218 |
| Sum | 1.3160895 × 108 |
| Variance | 10621602 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 26.28 | 12505 | 4.5% |
| 13.14 | 12303 | 4.4% |
| 19.71 | 7513 | 2.7% |
| 51.41682 | 5962 | 2.1% |
| 91.98 | 5917 | 2.1% |
| 24.966 | 4872 | 1.7% |
| 45.99 | 4305 | 1.5% |
| 131.4 | 3964 | 1.4% |
| 6.57 | 3631 | 1.3% |
| 65.7 | 3005 | 1.1% |
| Other values (42047) | 214610 |
| Value | Count | Frequency (%) |
| 0.01314 | 234 | |
| 0.02628 | 1 | < 0.1% |
| 0.03942 | 6 | < 0.1% |
| 0.07884 | 4 | < 0.1% |
| 0.09198 | 1 | < 0.1% |
| 0.11826 | 1 | < 0.1% |
| 0.1314 | 2 | < 0.1% |
| 0.14454 | 1 | < 0.1% |
| 0.17082 | 2 | < 0.1% |
| 0.18396 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 129950.0404 | 1 | |
| 129943.6544 | 1 | |
| 129775.239 | 1 | |
| 128271.8128 | 1 | |
| 127680.5128 | 1 | |
| 125749.8 | 1 | |
| 125746.9092 | 2 | |
| 125621.9872 | 2 | |
| 125317.8751 | 1 | |
| 123950.3296 | 1 |
| Distinct | 138 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 557174 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | FS |
|---|---|
| 2nd row | FS |
| 3rd row | FS |
| 4th row | FS |
| 5th row | FS |
| Value | Count | Frequency (%) |
| fs | 128128 | |
| br | 21290 | 7.6% |
| ms | 19033 | 6.8% |
| ha | 14551 | 5.2% |
| pc | 10135 | 3.6% |
| du | 9265 | 3.3% |
| th | 7685 | 2.8% |
| pf | 7010 | 2.5% |
| mn | 6112 | 2.2% |
| wv | 5199 | 1.9% |
| Other values (128) | 50179 | 18.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 154107 | |
| F | 141198 | |
| M | 30497 | 5.5% |
| H | 28364 | 5.1% |
| A | 27607 | 5.0% |
| R | 23782 | 4.3% |
| B | 22672 | 4.1% |
| P | 20884 | 3.7% |
| T | 20631 | 3.7% |
| D | 19487 | 3.5% |
| Other values (14) | 67945 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 557174 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 154107 | |
| F | 141198 | |
| M | 30497 | 5.5% |
| H | 28364 | 5.1% |
| A | 27607 | 5.0% |
| R | 23782 | 4.3% |
| B | 22672 | 4.1% |
| P | 20884 | 3.7% |
| T | 20631 | 3.7% |
| D | 19487 | 3.5% |
| Other values (14) | 67945 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 557174 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 154107 | |
| F | 141198 | |
| M | 30497 | 5.5% |
| H | 28364 | 5.1% |
| A | 27607 | 5.0% |
| R | 23782 | 4.3% |
| B | 22672 | 4.1% |
| P | 20884 | 3.7% |
| T | 20631 | 3.7% |
| D | 19487 | 3.5% |
| Other values (14) | 67945 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 557174 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 154107 | |
| F | 141198 | |
| M | 30497 | 5.5% |
| H | 28364 | 5.1% |
| A | 27607 | 5.0% |
| R | 23782 | 4.3% |
| B | 22672 | 4.1% |
| P | 20884 | 3.7% |
| T | 20631 | 3.7% |
| D | 19487 | 3.5% |
| Other values (14) | 67945 |
| Distinct | 138 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 28 |
| Mean length | 14.334642 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3993445 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | FUEL SURCHARGE |
|---|---|
| 2nd row | FUEL SURCHARGE |
| 3rd row | FUEL SURCHARGE |
| 4th row | FUEL SURCHARGE |
| 5th row | FUEL SURCHARGE |
| Value | Count | Frequency (%) |
| surcharge | 128430 | |
| fuel | 128128 | |
| charge | 28741 | 5.0% |
| brokerage | 21293 | 3.7% |
| custom | 21290 | 3.7% |
| msc | 19033 | 3.3% |
| chrgs | 19033 | 3.3% |
| handling | 14551 | 2.5% |
| fee | 12452 | 2.2% |
| duty | 11939 | 2.1% |
| Other values (203) | 166195 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 505318 | |
| R | 453241 | |
| U | 310563 | 7.8% |
| 292498 | 7.3% | |
| A | 289557 | 7.3% |
| C | 288302 | 7.2% |
| S | 260540 | 6.5% |
| G | 250825 | 6.3% |
| H | 216337 | 5.4% |
| L | 175857 | 4.4% |
| Other values (22) | 950407 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3687121 | |
| Space Separator | 292498 | 7.3% |
| Other Punctuation | 13235 | 0.3% |
| Dash Punctuation | 501 | < 0.1% |
| Open Punctuation | 45 | < 0.1% |
| Close Punctuation | 45 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 505318 | |
| R | 453241 | |
| U | 310563 | |
| A | 289557 | 7.9% |
| C | 288302 | 7.8% |
| S | 260540 | 7.1% |
| G | 250825 | 6.8% |
| H | 216337 | 5.9% |
| L | 175857 | 4.8% |
| F | 172995 | 4.7% |
| Other values (16) | 763586 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 13227 | |
| & | 8 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 292498 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 501 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 45 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 45 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3687121 | |
| Common | 306324 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 505318 | |
| R | 453241 | |
| U | 310563 | |
| A | 289557 | 7.9% |
| C | 288302 | 7.8% |
| S | 260540 | 7.1% |
| G | 250825 | 6.8% |
| H | 216337 | 5.9% |
| L | 175857 | 4.8% |
| F | 172995 | 4.7% |
| Other values (16) | 763586 |
Common
| Value | Count | Frequency (%) |
| 292498 | ||
| / | 13227 | 4.3% |
| - | 501 | 0.2% |
| ( | 45 | < 0.1% |
| ) | 45 | < 0.1% |
| & | 8 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3993445 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 505318 | |
| R | 453241 | |
| U | 310563 | 7.8% |
| 292498 | 7.3% | |
| A | 289557 | 7.3% |
| C | 288302 | 7.2% |
| S | 260540 | 6.5% |
| G | 250825 | 6.3% |
| H | 216337 | 5.4% |
| L | 175857 | 4.4% |
| Other values (22) | 950407 |
AMOUNT_PAID
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 62830 |
|---|---|
| Distinct (%) | 22.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3580.7642 |
| Minimum | 0.01314 |
|---|---|
| Maximum | 934680.96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 0.01314 |
|---|---|
| 5-th percentile | 111.40092 |
| Q1 | 222.32223 |
| median | 734.7231 |
| Q3 | 2479.4654 |
| 95-th percentile | 11885.13 |
| Maximum | 934680.96 |
| Range | 934680.94 |
| Interquartile range (IQR) | 2257.1432 |
Descriptive statistics
| Standard deviation | 16659.259 |
|---|---|
| Coefficient of variation (CV) | 4.6524313 |
| Kurtosis | 1036.671 |
| Mean | 3580.7642 |
| Median Absolute Deviation (MAD) | 590.09112 |
| Skewness | 26.056385 |
| Sum | 9.9755435 × 108 |
| Variance | 2.7753092 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91.98 | 1324 | 0.5% |
| 51.7716 | 816 | 0.3% |
| 64.55682 | 719 | 0.3% |
| 785.6406 | 649 | 0.2% |
| 1859.31 | 564 | 0.2% |
| 429.678 | 558 | 0.2% |
| 65.7 | 522 | 0.2% |
| 2168.1 | 428 | 0.2% |
| 96.40818 | 321 | 0.1% |
| 96.579 | 288 | 0.1% |
| Other values (62820) | 272398 |
| Value | Count | Frequency (%) |
| 0.01314 | 1 | < 0.1% |
| 0.07884 | 1 | < 0.1% |
| 1.314 | 1 | < 0.1% |
| 6.57 | 3 | |
| 6.59628 | 1 | < 0.1% |
| 7.34526 | 1 | < 0.1% |
| 8.6067 | 1 | < 0.1% |
| 8.65926 | 1 | < 0.1% |
| 9.90756 | 1 | < 0.1% |
| 11.826 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 934680.958 | 1 | < 0.1% |
| 896151.9946 | 12 | |
| 846140.4319 | 12 | |
| 802120.1836 | 4 | < 0.1% |
| 655493.9589 | 8 | |
| 592760.6161 | 6 | |
| 563688.5501 | 8 | |
| 555631.1546 | 3 | < 0.1% |
| 533514.695 | 6 | |
| 461741.0323 | 6 |
BILL_DATE
Date
| Distinct | 1497 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| Minimum | 2019-03-26 00:00:00 |
|---|---|
| Maximum | 2024-02-05 00:00:00 |
BILL_TYPE
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| LINEHAUL | |
|---|---|
| BALANCE DUE | |
| SEP. BILLED ACC. | 2695 |
Length
| Max length | 16 |
|---|---|
| Median length | 8 |
| Mean length | 8.6165543 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2400460 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LINEHAUL |
|---|---|
| 2nd row | LINEHAUL |
| 3rd row | LINEHAUL |
| 4th row | LINEHAUL |
| 5th row | LINEHAUL |
Common Values
| Value | Count | Frequency (%) |
| LINEHAUL | 225824 | |
| BALANCE DUE | 50068 | 18.0% |
| SEP. BILLED ACC. | 2695 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| linehaul | 225824 | |
| balance | 50068 | 15.0% |
| due | 50068 | 15.0% |
| sep | 2695 | 0.8% |
| billed | 2695 | 0.8% |
| acc | 2695 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 507106 | |
| E | 331350 | |
| A | 328655 | |
| N | 275892 | |
| U | 275892 | |
| I | 228519 | |
| H | 225824 | |
| C | 55458 | 2.3% |
| 55458 | 2.3% | |
| B | 52763 | 2.2% |
| Other values (4) | 63543 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2339612 | |
| Space Separator | 55458 | 2.3% |
| Other Punctuation | 5390 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 507106 | |
| E | 331350 | |
| A | 328655 | |
| N | 275892 | |
| U | 275892 | |
| I | 228519 | |
| H | 225824 | |
| C | 55458 | 2.4% |
| B | 52763 | 2.3% |
| D | 52763 | 2.3% |
| Other values (2) | 5390 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 55458 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5390 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2339612 | |
| Common | 60848 | 2.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 507106 | |
| E | 331350 | |
| A | 328655 | |
| N | 275892 | |
| U | 275892 | |
| I | 228519 | |
| H | 225824 | |
| C | 55458 | 2.4% |
| B | 52763 | 2.3% |
| D | 52763 | 2.3% |
| Other values (2) | 5390 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 55458 | ||
| . | 5390 | 8.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2400460 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 507106 | |
| E | 331350 | |
| A | 328655 | |
| N | 275892 | |
| U | 275892 | |
| I | 228519 | |
| H | 225824 | |
| C | 55458 | 2.3% |
| 55458 | 2.3% | |
| B | 52763 | 2.2% |
| Other values (4) | 63543 | 2.6% |
CARRIER_MODE_DESCRIPTION
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| MOTOR | |
|---|---|
| AIR | |
| INTERNATIO | 19 |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 4.5060609 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1255330 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MOTOR |
|---|---|
| 2nd row | MOTOR |
| 3rd row | MOTOR |
| 4th row | MOTOR |
| 5th row | MOTOR |
Common Values
| Value | Count | Frequency (%) |
| MOTOR | 209718 | |
| AIR | 68850 | 24.7% |
| INTERNATIO | 19 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| motor | 209718 | |
| air | 68850 | 24.7% |
| internatio | 19 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 419455 | |
| R | 278587 | |
| T | 209756 | |
| M | 209718 | |
| I | 68888 | 5.5% |
| A | 68869 | 5.5% |
| N | 38 | < 0.1% |
| E | 19 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1255330 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 419455 | |
| R | 278587 | |
| T | 209756 | |
| M | 209718 | |
| I | 68888 | 5.5% |
| A | 68869 | 5.5% |
| N | 38 | < 0.1% |
| E | 19 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1255330 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 419455 | |
| R | 278587 | |
| T | 209756 | |
| M | 209718 | |
| I | 68888 | 5.5% |
| A | 68869 | 5.5% |
| N | 38 | < 0.1% |
| E | 19 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1255330 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 419455 | |
| R | 278587 | |
| T | 209756 | |
| M | 209718 | |
| I | 68888 | 5.5% |
| A | 68869 | 5.5% |
| N | 38 | < 0.1% |
| E | 19 | < 0.1% |
CARRIER_NAME2
Text
| Distinct | 80 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 30 |
| Mean length | 18.913754 |
| Min length | 7 |
Characters and Unicode
| Total characters | 5269126 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Young Ltd |
|---|---|
| 2nd row | Young Ltd |
| 3rd row | Young Ltd |
| 4th row | Young Ltd |
| 5th row | Young Ltd |
| Value | Count | Frequency (%) |
| and | 144990 | |
| hodges | 67773 | 9.1% |
| weaver | 67773 | 9.1% |
| lyons | 67773 | 9.1% |
| taylor-newman | 40926 | 5.5% |
| morales | 34991 | 4.7% |
| anderson-esparza | 31439 | 4.2% |
| torres | 30715 | 4.1% |
| peck | 30414 | 4.1% |
| inc | 16618 | 2.2% |
| Other values (116) | 209958 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 538645 | 10.2% |
| 464783 | 8.8% | |
| a | 461560 | 8.8% |
| n | 442305 | 8.4% |
| o | 402202 | 7.6% |
| r | 384976 | 7.3% |
| s | 354879 | 6.7% |
| d | 285446 | 5.4% |
| , | 144968 | 2.8% |
| y | 134464 | 2.6% |
| Other values (40) | 1654898 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3837165 | |
| Uppercase Letter | 718448 | 13.6% |
| Space Separator | 464783 | 8.8% |
| Other Punctuation | 144968 | 2.8% |
| Dash Punctuation | 103762 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 538645 | |
| a | 461560 | |
| n | 442305 | |
| o | 402202 | |
| r | 384976 | |
| s | 354879 | |
| d | 285446 | |
| y | 134464 | 3.5% |
| l | 115911 | 3.0% |
| g | 101682 | 2.6% |
| Other values (15) | 615095 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 115629 | |
| H | 78254 | |
| W | 72963 | |
| T | 71731 | |
| P | 52690 | 7.3% |
| M | 43039 | 6.0% |
| N | 40926 | 5.7% |
| A | 38138 | 5.3% |
| E | 36061 | 5.0% |
| D | 31661 | 4.4% |
| Other values (12) | 137356 |
Space Separator
| Value | Count | Frequency (%) |
| 464783 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 144968 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 103762 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4555613 | |
| Common | 713513 | 13.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 538645 | |
| a | 461560 | 10.1% |
| n | 442305 | 9.7% |
| o | 402202 | 8.8% |
| r | 384976 | 8.5% |
| s | 354879 | 7.8% |
| d | 285446 | 6.3% |
| y | 134464 | 3.0% |
| l | 115911 | 2.5% |
| L | 115629 | 2.5% |
| Other values (37) | 1319596 |
Common
| Value | Count | Frequency (%) |
| 464783 | ||
| , | 144968 | 20.3% |
| - | 103762 | 14.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5269126 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 538645 | 10.2% |
| 464783 | 8.8% | |
| a | 461560 | 8.8% |
| n | 442305 | 8.4% |
| o | 402202 | 7.6% |
| r | 384976 | 7.3% |
| s | 354879 | 6.7% |
| d | 285446 | 5.4% |
| , | 144968 | 2.8% |
| y | 134464 | 2.6% |
| Other values (40) | 1654898 |
DESTINATION_CITY
Text
| Distinct | 2078 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 8.5738315 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2388558 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 345 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BROKEN ARROW |
|---|---|
| 2nd row | SAN DIEGO |
| 3rd row | SAN DIEGO |
| 4th row | SAN DIEGO |
| 5th row | SAN DIEGO |
| Value | Count | Frequency (%) |
| san | 99933 | |
| diego | 98645 | |
| desoto | 16431 | 4.0% |
| fairburn | 15427 | 3.7% |
| bitozeves | 14435 | 3.5% |
| mabank | 8955 | 2.2% |
| zatec | 8338 | 2.0% |
| zebrak | 7192 | 1.7% |
| houston | 6758 | 1.6% |
| gardena | 5685 | 1.4% |
| Other values (2149) | 133101 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 269633 | |
| A | 244147 | |
| O | 241044 | |
| N | 228250 | |
| I | 187523 | 7.9% |
| S | 179826 | 7.5% |
| D | 141776 | 5.9% |
| 136534 | 5.7% | |
| G | 131238 | 5.5% |
| R | 118707 | 5.0% |
| Other values (23) | 509880 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2251966 | |
| Space Separator | 136534 | 5.7% |
| Open Punctuation | 20 | < 0.1% |
| Dash Punctuation | 16 | < 0.1% |
| Other Punctuation | 16 | < 0.1% |
| Decimal Number | 6 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 269633 | |
| A | 244147 | |
| O | 241044 | |
| N | 228250 | |
| I | 187523 | |
| S | 179826 | |
| D | 141776 | 6.3% |
| G | 131238 | 5.8% |
| R | 118707 | 5.3% |
| T | 79103 | 3.5% |
| Other values (16) | 430719 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 10 | |
| , | 6 |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 3 | |
| 0 | 3 |
Space Separator
| Value | Count | Frequency (%) |
| 136534 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 20 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 16 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2251966 | |
| Common | 136592 | 5.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 269633 | |
| A | 244147 | |
| O | 241044 | |
| N | 228250 | |
| I | 187523 | |
| S | 179826 | |
| D | 141776 | 6.3% |
| G | 131238 | 5.8% |
| R | 118707 | 5.3% |
| T | 79103 | 3.5% |
| Other values (16) | 430719 |
Common
| Value | Count | Frequency (%) |
| 136534 | ||
| ( | 20 | < 0.1% |
| - | 16 | < 0.1% |
| . | 10 | < 0.1% |
| , | 6 | < 0.1% |
| 9 | 3 | < 0.1% |
| 0 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2388558 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 269633 | |
| A | 244147 | |
| O | 241044 | |
| N | 228250 | |
| I | 187523 | 7.9% |
| S | 179826 | 7.5% |
| D | 141776 | 5.9% |
| 136534 | 5.7% | |
| G | 131238 | 5.5% |
| R | 118707 | 5.0% |
| Other values (23) | 509880 |
MISSING 
| Distinct | 98 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2813 |
| Missing (%) | 1.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 551548 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| us | 206598 | |
| cz | 33761 | 12.2% |
| be | 8303 | 3.0% |
| au | 7034 | 2.6% |
| de | 4166 | 1.5% |
| cn | 2966 | 1.1% |
| gb | 2587 | 0.9% |
| uk | 1378 | 0.5% |
| ca | 882 | 0.3% |
| hk | 788 | 0.3% |
| Other values (88) | 7311 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 215203 | |
| S | 207543 | |
| C | 38135 | 6.9% |
| Z | 34264 | 6.2% |
| E | 13732 | 2.5% |
| B | 11268 | 2.0% |
| A | 8449 | 1.5% |
| D | 5150 | 0.9% |
| N | 3944 | 0.7% |
| K | 3540 | 0.6% |
| Other values (16) | 10320 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 551548 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 215203 | |
| S | 207543 | |
| C | 38135 | 6.9% |
| Z | 34264 | 6.2% |
| E | 13732 | 2.5% |
| B | 11268 | 2.0% |
| A | 8449 | 1.5% |
| D | 5150 | 0.9% |
| N | 3944 | 0.7% |
| K | 3540 | 0.6% |
| Other values (16) | 10320 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 551548 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 215203 | |
| S | 207543 | |
| C | 38135 | 6.9% |
| Z | 34264 | 6.2% |
| E | 13732 | 2.5% |
| B | 11268 | 2.0% |
| A | 8449 | 1.5% |
| D | 5150 | 0.9% |
| N | 3944 | 0.7% |
| K | 3540 | 0.6% |
| Other values (16) | 10320 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 551548 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 215203 | |
| S | 207543 | |
| C | 38135 | 6.9% |
| Z | 34264 | 6.2% |
| E | 13732 | 2.5% |
| B | 11268 | 2.0% |
| A | 8449 | 1.5% |
| D | 5150 | 0.9% |
| N | 3944 | 0.7% |
| K | 3540 | 0.6% |
| Other values (16) | 10320 | 1.9% |
| Distinct | 4857 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 23 |
| Mean length | 13.90963 |
| Min length | 7 |
Characters and Unicode
| Total characters | 3875042 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1526 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | Christopher Shepard |
|---|---|
| 2nd row | Ashley Cruz |
| 3rd row | Jeremy Colon |
| 4th row | Ashley Cruz |
| 5th row | Ashley Cruz |
| Value | Count | Frequency (%) |
| christopher | 71518 | 12.8% |
| shepard | 70419 | 12.6% |
| brown | 43095 | 7.7% |
| ryan | 42861 | 7.7% |
| ashley | 27221 | 4.9% |
| cruz | 26182 | 4.7% |
| michael | 15021 | 2.7% |
| carl | 12841 | 2.3% |
| ramsey | 12828 | 2.3% |
| clark | 12320 | 2.2% |
| Other values (1439) | 225443 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 392493 | 10.1% |
| e | 333851 | 8.6% |
| h | 308031 | 7.9% |
| 281162 | 7.3% | |
| a | 279669 | 7.2% |
| i | 199794 | 5.2% |
| o | 198445 | 5.1% |
| n | 192285 | 5.0% |
| s | 176130 | 4.5% |
| l | 167970 | 4.3% |
| Other values (44) | 1345212 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3030966 | |
| Uppercase Letter | 561766 | 14.5% |
| Space Separator | 281162 | 7.3% |
| Other Punctuation | 1148 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 392493 | |
| e | 333851 | |
| h | 308031 | |
| a | 279669 | |
| i | 199794 | 6.6% |
| o | 198445 | 6.5% |
| n | 192285 | 6.3% |
| s | 176130 | 5.8% |
| l | 167970 | 5.5% |
| p | 154036 | 5.1% |
| Other values (16) | 628262 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 142670 | |
| S | 86964 | |
| R | 71124 | |
| B | 49798 | 8.9% |
| A | 36956 | 6.6% |
| M | 34928 | 6.2% |
| J | 20954 | 3.7% |
| T | 18063 | 3.2% |
| D | 15996 | 2.8% |
| K | 12112 | 2.2% |
| Other values (16) | 72201 |
Space Separator
| Value | Count | Frequency (%) |
| 281162 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1148 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3592732 | |
| Common | 282310 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 392493 | 10.9% |
| e | 333851 | 9.3% |
| h | 308031 | 8.6% |
| a | 279669 | 7.8% |
| i | 199794 | 5.6% |
| o | 198445 | 5.5% |
| n | 192285 | 5.4% |
| s | 176130 | 4.9% |
| l | 167970 | 4.7% |
| p | 154036 | 4.3% |
| Other values (42) | 1190028 |
Common
| Value | Count | Frequency (%) |
| 281162 | ||
| . | 1148 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3875042 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 392493 | 10.1% |
| e | 333851 | 8.6% |
| h | 308031 | 7.9% |
| 281162 | 7.3% | |
| a | 279669 | 7.2% |
| i | 199794 | 5.2% |
| o | 198445 | 5.1% |
| n | 192285 | 5.0% |
| s | 176130 | 4.5% |
| l | 167970 | 4.3% |
| Other values (44) | 1345212 |
MISSING 
| Distinct | 112 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3286 |
| Missing (%) | 1.2% |
| Memory size | 2.1 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.9999818 |
| Min length | 1 |
Characters and Unicode
| Total characters | 550597 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OK |
|---|---|
| 2nd row | CA |
| 3rd row | CA |
| 4th row | CA |
| 5th row | CA |
| Value | Count | Frequency (%) |
| ca | 122454 | |
| xx | 59558 | |
| tx | 43569 | 15.8% |
| ga | 17178 | 6.2% |
| ok | 4920 | 1.8% |
| cz | 4293 | 1.6% |
| la | 3793 | 1.4% |
| az | 2269 | 0.8% |
| pa | 1057 | 0.4% |
| oh | 970 | 0.4% |
| Other values (102) | 15240 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| X | 162780 | |
| A | 149185 | |
| C | 128469 | |
| T | 44514 | 8.1% |
| G | 17657 | 3.2% |
| O | 7095 | 1.3% |
| Z | 6592 | 1.2% |
| K | 5916 | 1.1% |
| L | 5463 | 1.0% |
| N | 3164 | 0.6% |
| Other values (17) | 19762 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 550557 | |
| Currency Symbol | 40 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 162780 | |
| A | 149185 | |
| C | 128469 | |
| T | 44514 | 8.1% |
| G | 17657 | 3.2% |
| O | 7095 | 1.3% |
| Z | 6592 | 1.2% |
| K | 5916 | 1.1% |
| L | 5463 | 1.0% |
| N | 3164 | 0.6% |
| Other values (16) | 19722 | 3.6% |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 40 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 550557 | |
| Common | 40 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 162780 | |
| A | 149185 | |
| C | 128469 | |
| T | 44514 | 8.1% |
| G | 17657 | 3.2% |
| O | 7095 | 1.3% |
| Z | 6592 | 1.2% |
| K | 5916 | 1.1% |
| L | 5463 | 1.0% |
| N | 3164 | 0.6% |
| Other values (16) | 19722 | 3.6% |
Common
| Value | Count | Frequency (%) |
| $ | 40 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 550597 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| X | 162780 | |
| A | 149185 | |
| C | 128469 | |
| T | 44514 | 8.1% |
| G | 17657 | 3.2% |
| O | 7095 | 1.3% |
| Z | 6592 | 1.2% |
| K | 5916 | 1.1% |
| L | 5463 | 1.0% |
| N | 3164 | 0.6% |
| Other values (17) | 19762 | 3.6% |
DESTINATION_ZIP
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 153 |
|---|---|
| Missing (%) | 0.1% |
| Memory size | 2.1 MiB |
IO_CODE
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 1 | |
|---|---|
| 2 | |
| 4 | |
| 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 278587 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 105345 | |
| 2 | 104060 | |
| 4 | 39929 | 14.3% |
| 3 | 29253 | 10.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 105345 | |
| 2 | 104060 | |
| 4 | 39929 | 14.3% |
| 3 | 29253 | 10.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 105345 | |
| 2 | 104060 | |
| 4 | 39929 | 14.3% |
| 3 | 29253 | 10.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 278587 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 105345 | |
| 2 | 104060 | |
| 4 | 39929 | 14.3% |
| 3 | 29253 | 10.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 278587 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 105345 | |
| 2 | 104060 | |
| 4 | 39929 | 14.3% |
| 3 | 29253 | 10.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 278587 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 105345 | |
| 2 | 104060 | |
| 4 | 39929 | 14.3% |
| 3 | 29253 | 10.5% |
IO_CODE_DESCRIPTION
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| Inbound | |
|---|---|
| Outbound | |
| Third Party | |
| Interfacility |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 8.5768647 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2389403 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Inbound |
|---|---|
| 2nd row | Inbound |
| 3rd row | Inbound |
| 4th row | Inbound |
| 5th row | Inbound |
Common Values
| Value | Count | Frequency (%) |
| Inbound | 105345 | |
| Outbound | 104060 | |
| Third Party | 39929 | 14.3% |
| Interfacility | 29253 | 10.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| inbound | 105345 | |
| outbound | 104060 | |
| third | 39929 | 12.5% |
| party | 39929 | 12.5% |
| interfacility | 29253 | 9.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 344003 | |
| u | 313465 | |
| d | 249334 | |
| b | 209405 | |
| o | 209405 | |
| t | 202495 | |
| I | 134598 | 5.6% |
| r | 109111 | 4.6% |
| O | 104060 | 4.4% |
| i | 98435 | 4.1% |
| Other values (10) | 415092 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2030958 | |
| Uppercase Letter | 318516 | 13.3% |
| Space Separator | 39929 | 1.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 344003 | |
| u | 313465 | |
| d | 249334 | |
| b | 209405 | |
| o | 209405 | |
| t | 202495 | |
| r | 109111 | 5.4% |
| i | 98435 | 4.8% |
| a | 69182 | 3.4% |
| y | 69182 | 3.4% |
| Other values (5) | 156941 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 134598 | |
| O | 104060 | |
| T | 39929 | 12.5% |
| P | 39929 | 12.5% |
Space Separator
| Value | Count | Frequency (%) |
| 39929 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2349474 | |
| Common | 39929 | 1.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 344003 | |
| u | 313465 | |
| d | 249334 | |
| b | 209405 | |
| o | 209405 | |
| t | 202495 | |
| I | 134598 | 5.7% |
| r | 109111 | 4.6% |
| O | 104060 | 4.4% |
| i | 98435 | 4.2% |
| Other values (9) | 375163 |
Common
| Value | Count | Frequency (%) |
| 39929 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2389403 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 344003 | |
| u | 313465 | |
| d | 249334 | |
| b | 209405 | |
| o | 209405 | |
| t | 202495 | |
| I | 134598 | 5.6% |
| r | 109111 | 4.6% |
| O | 104060 | 4.4% |
| i | 98435 | 4.1% |
| Other values (10) | 415092 |
MILEAGE
Real number (ℝ)
ZEROS 
| Distinct | 2537 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 600.88452 |
| Minimum | 0 |
|---|---|
| Maximum | 4814 |
| Zeros | 128368 |
| Zeros (%) | 46.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 31 |
| Q3 | 1107 |
| 95-th percentile | 2302 |
| Maximum | 4814 |
| Range | 4814 |
| Interquartile range (IQR) | 1107 |
Descriptive statistics
| Standard deviation | 826.57897 |
|---|---|
| Coefficient of variation (CV) | 1.3756037 |
| Kurtosis | 0.22777737 |
| Mean | 600.88452 |
| Median Absolute Deviation (MAD) | 31 |
| Skewness | 1.1795863 |
| Sum | 1.6739862 × 108 |
| Variance | 683232.79 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 128368 | |
| 1102 | 6804 | 2.4% |
| 1345 | 4079 | 1.5% |
| 2118 | 2864 | 1.0% |
| 112 | 2576 | 0.9% |
| 352 | 2507 | 0.9% |
| 1024 | 2410 | 0.9% |
| 117 | 2400 | 0.9% |
| 1474 | 2390 | 0.9% |
| 1392 | 2313 | 0.8% |
| Other values (2527) | 121876 |
| Value | Count | Frequency (%) |
| 0 | 128368 | |
| 2 | 4 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 963 | 0.3% |
| 5 | 6 | < 0.1% |
| 6 | 79 | < 0.1% |
| 7 | 56 | < 0.1% |
| 8 | 384 | 0.1% |
| 9 | 1596 | 0.6% |
| 10 | 694 | 0.2% |
| Value | Count | Frequency (%) |
| 4814 | 2 | < 0.1% |
| 4653 | 3 | < 0.1% |
| 4651 | 12 | |
| 4541 | 2 | < 0.1% |
| 4432 | 2 | < 0.1% |
| 4394 | 7 | < 0.1% |
| 4359 | 7 | < 0.1% |
| 4332 | 2 | < 0.1% |
| 4320 | 19 | |
| 4262 | 8 |
ORIGIN_CITY
Text
| Distinct | 1962 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 18 |
| Mean length | 8.2064238 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2286203 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 371 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | MOUNTAIN TOP |
|---|---|
| 2nd row | SHAKOPEE |
| 3rd row | ALEXANDER |
| 4th row | FLORENCE |
| 5th row | FLORENCE |
| Value | Count | Frequency (%) |
| san | 50201 | 13.7% |
| diego | 48853 | 13.4% |
| fairburn | 36962 | 10.1% |
| tijuana | 27079 | 7.4% |
| desoto | 25277 | 6.9% |
| ontario | 6934 | 1.9% |
| mabank | 6763 | 1.9% |
| houston | 5434 | 1.5% |
| channelview | 4857 | 1.3% |
| south | 4690 | 1.3% |
| Other values (2006) | 148333 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 279592 | |
| N | 242970 | |
| O | 217165 | 9.5% |
| I | 185174 | 8.1% |
| E | 182973 | 8.0% |
| R | 150669 | 6.6% |
| S | 133085 | 5.8% |
| T | 117794 | 5.2% |
| D | 106385 | 4.7% |
| U | 93625 | 4.1% |
| Other values (29) | 576771 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2197926 | |
| Space Separator | 87888 | 3.8% |
| Decimal Number | 204 | < 0.1% |
| Dash Punctuation | 137 | < 0.1% |
| Other Punctuation | 34 | < 0.1% |
| Open Punctuation | 11 | < 0.1% |
| Close Punctuation | 3 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 279592 | |
| N | 242970 | |
| O | 217165 | |
| I | 185174 | 8.4% |
| E | 182973 | 8.3% |
| R | 150669 | 6.9% |
| S | 133085 | 6.1% |
| T | 117794 | 5.4% |
| D | 106385 | 4.8% |
| U | 93625 | 4.3% |
| Other values (16) | 488494 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 85 | |
| 0 | 48 | |
| 3 | 38 | |
| 2 | 31 | 15.2% |
| 6 | 2 | 1.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 20 | |
| . | 7 | 20.6% |
| / | 5 | 14.7% |
| " | 2 | 5.9% |
Space Separator
| Value | Count | Frequency (%) |
| 87888 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 137 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 11 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2197926 | |
| Common | 88277 | 3.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 279592 | |
| N | 242970 | |
| O | 217165 | |
| I | 185174 | 8.4% |
| E | 182973 | 8.3% |
| R | 150669 | 6.9% |
| S | 133085 | 6.1% |
| T | 117794 | 5.4% |
| D | 106385 | 4.8% |
| U | 93625 | 4.3% |
| Other values (16) | 488494 |
Common
| Value | Count | Frequency (%) |
| 87888 | ||
| - | 137 | 0.2% |
| 1 | 85 | 0.1% |
| 0 | 48 | 0.1% |
| 3 | 38 | < 0.1% |
| 2 | 31 | < 0.1% |
| , | 20 | < 0.1% |
| ( | 11 | < 0.1% |
| . | 7 | < 0.1% |
| / | 5 | < 0.1% |
| Other values (3) | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2286203 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 279592 | |
| N | 242970 | |
| O | 217165 | 9.5% |
| I | 185174 | 8.1% |
| E | 182973 | 8.0% |
| R | 150669 | 6.6% |
| S | 133085 | 5.8% |
| T | 117794 | 5.2% |
| D | 106385 | 4.7% |
| U | 93625 | 4.1% |
| Other values (29) | 576771 |
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1714 |
| Missing (%) | 0.6% |
| Memory size | 2.1 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 553746 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| us | 218086 | |
| mx | 28519 | 10.3% |
| ca | 7642 | 2.8% |
| cz | 3050 | 1.1% |
| jp | 2600 | 0.9% |
| de | 2222 | 0.8% |
| it | 1907 | 0.7% |
| tr | 1793 | 0.6% |
| gb | 1489 | 0.5% |
| uk | 1223 | 0.4% |
| Other values (74) | 8342 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 219855 | |
| S | 219740 | |
| M | 28813 | 5.2% |
| X | 28523 | 5.2% |
| C | 11618 | 2.1% |
| A | 9141 | 1.7% |
| T | 4665 | 0.8% |
| E | 3854 | 0.7% |
| I | 3165 | 0.6% |
| Z | 3083 | 0.6% |
| Other values (16) | 21289 | 3.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 553746 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 219855 | |
| S | 219740 | |
| M | 28813 | 5.2% |
| X | 28523 | 5.2% |
| C | 11618 | 2.1% |
| A | 9141 | 1.7% |
| T | 4665 | 0.8% |
| E | 3854 | 0.7% |
| I | 3165 | 0.6% |
| Z | 3083 | 0.6% |
| Other values (16) | 21289 | 3.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 553746 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 219855 | |
| S | 219740 | |
| M | 28813 | 5.2% |
| X | 28523 | 5.2% |
| C | 11618 | 2.1% |
| A | 9141 | 1.7% |
| T | 4665 | 0.8% |
| E | 3854 | 0.7% |
| I | 3165 | 0.6% |
| Z | 3083 | 0.6% |
| Other values (16) | 21289 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 553746 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 219855 | |
| S | 219740 | |
| M | 28813 | 5.2% |
| X | 28523 | 5.2% |
| C | 11618 | 2.1% |
| A | 9141 | 1.7% |
| T | 4665 | 0.8% |
| E | 3854 | 0.7% |
| I | 3165 | 0.6% |
| Z | 3083 | 0.6% |
| Other values (16) | 21289 | 3.8% |
ORIGIN_NAME2
Text
| Distinct | 4931 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 2.1 MiB |
Length
| Max length | 28 |
|---|---|
| Median length | 26 |
| Mean length | 13.033458 |
| Min length | 7 |
Characters and Unicode
| Total characters | 3630939 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1600 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | Derrick Castro |
|---|---|
| 2nd row | Jason Harvey |
| 3rd row | Julia Nielsen |
| 4th row | Richard Wright |
| 5th row | Richard Wright |
| Value | Count | Frequency (%) |
| nguyen | 36781 | 6.5% |
| kristie | 36690 | 6.5% |
| gregory | 23676 | 4.2% |
| avery | 23153 | 4.1% |
| sanchez | 16425 | 2.9% |
| roy | 16361 | 2.9% |
| mary | 14356 | 2.5% |
| calderon | 14201 | 2.5% |
| lisa | 13354 | 2.4% |
| eric | 13104 | 2.3% |
| Other values (1451) | 355436 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 367138 | 10.1% |
| r | 303769 | 8.4% |
| 284951 | 7.8% | |
| a | 258688 | 7.1% |
| n | 236268 | 6.5% |
| i | 221608 | 6.1% |
| o | 199356 | 5.5% |
| y | 176315 | 4.9% |
| l | 160662 | 4.4% |
| s | 150508 | 4.1% |
| Other values (44) | 1271676 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2775280 | |
| Uppercase Letter | 568011 | 15.6% |
| Space Separator | 284951 | 7.8% |
| Other Punctuation | 2697 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 367138 | |
| r | 303769 | |
| a | 258688 | |
| n | 236268 | |
| i | 221608 | 8.0% |
| o | 199356 | 7.2% |
| y | 176315 | 6.4% |
| l | 160662 | 5.8% |
| s | 150508 | 5.4% |
| t | 139637 | 5.0% |
| Other values (16) | 561331 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 57110 | 10.1% |
| A | 52236 | 9.2% |
| K | 45669 | 8.0% |
| N | 43817 | 7.7% |
| C | 41718 | 7.3% |
| M | 37843 | 6.7% |
| L | 35071 | 6.2% |
| H | 34390 | 6.1% |
| B | 32625 | 5.7% |
| G | 31509 | 5.5% |
| Other values (16) | 156023 |
Space Separator
| Value | Count | Frequency (%) |
| 284951 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2697 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3343291 | |
| Common | 287648 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 367138 | 11.0% |
| r | 303769 | 9.1% |
| a | 258688 | 7.7% |
| n | 236268 | 7.1% |
| i | 221608 | 6.6% |
| o | 199356 | 6.0% |
| y | 176315 | 5.3% |
| l | 160662 | 4.8% |
| s | 150508 | 4.5% |
| t | 139637 | 4.2% |
| Other values (42) | 1129342 |
Common
| Value | Count | Frequency (%) |
| 284951 | ||
| . | 2697 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3630939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 367138 | 10.1% |
| r | 303769 | 8.4% |
| 284951 | 7.8% | |
| a | 258688 | 7.1% |
| n | 236268 | 6.5% |
| i | 221608 | 6.1% |
| o | 199356 | 5.5% |
| y | 176315 | 4.9% |
| l | 160662 | 4.4% |
| s | 150508 | 4.1% |
| Other values (44) | 1271676 |
ORIGIN_STATE
Text
MISSING 
| Distinct | 100 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6996 |
| Missing (%) | 2.5% |
| Memory size | 2.1 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 543182 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PA |
|---|---|
| 2nd row | MN |
| 3rd row | AR |
| 4th row | KY |
| 5th row | KY |
| Value | Count | Frequency (%) |
| ca | 84115 | |
| tx | 50417 | |
| ga | 40728 | |
| xx | 16992 | 6.3% |
| bc | 14238 | 5.2% |
| mx | 12638 | 4.7% |
| on | 5657 | 2.1% |
| oh | 4832 | 1.8% |
| ok | 4565 | 1.7% |
| az | 4302 | 1.6% |
| Other values (90) | 33107 | 12.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 137381 | |
| C | 103359 | |
| X | 97039 | |
| T | 53216 | 9.8% |
| G | 40821 | 7.5% |
| M | 18481 | 3.4% |
| O | 16819 | 3.1% |
| B | 14998 | 2.8% |
| N | 14073 | 2.6% |
| I | 7805 | 1.4% |
| Other values (16) | 39190 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 543182 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 137381 | |
| C | 103359 | |
| X | 97039 | |
| T | 53216 | 9.8% |
| G | 40821 | 7.5% |
| M | 18481 | 3.4% |
| O | 16819 | 3.1% |
| B | 14998 | 2.8% |
| N | 14073 | 2.6% |
| I | 7805 | 1.4% |
| Other values (16) | 39190 | 7.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 543182 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 137381 | |
| C | 103359 | |
| X | 97039 | |
| T | 53216 | 9.8% |
| G | 40821 | 7.5% |
| M | 18481 | 3.4% |
| O | 16819 | 3.1% |
| B | 14998 | 2.8% |
| N | 14073 | 2.6% |
| I | 7805 | 1.4% |
| Other values (16) | 39190 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 543182 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 137381 | |
| C | 103359 | |
| X | 97039 | |
| T | 53216 | 9.8% |
| G | 40821 | 7.5% |
| M | 18481 | 3.4% |
| O | 16819 | 3.1% |
| B | 14998 | 2.8% |
| N | 14073 | 2.6% |
| I | 7805 | 1.4% |
| Other values (16) | 39190 | 7.2% |
ORIGIN_ZIP
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 148 |
|---|---|
| Missing (%) | 0.1% |
| Memory size | 2.1 MiB |
PROCESS_DATE
Date
| Distinct | 1045 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| Minimum | 2020-01-06 00:00:00 |
|---|---|
| Maximum | 2024-02-06 00:00:00 |
PRO_NUMBER2
Real number (ℝ)
MISSING 
| Distinct | 147178 |
|---|---|
| Distinct (%) | 54.7% |
| Missing | 9317 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0010035 × 1012 |
| Minimum | 1.3514963 × 108 |
|---|---|
| Maximum | 9.9999377 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 1.3514963 × 108 |
|---|---|
| 5-th percentile | 4.9159138 × 1011 |
| Q1 | 2.4984058 × 1012 |
| median | 5.0039166 × 1012 |
| Q3 | 7.5013252 × 1012 |
| 95-th percentile | 9.5041179 × 1012 |
| Maximum | 9.9999377 × 1012 |
| Range | 9.9998025 × 1012 |
| Interquartile range (IQR) | 5.0029195 × 1012 |
Descriptive statistics
| Standard deviation | 2.8890583 × 1012 |
|---|---|
| Coefficient of variation (CV) | 0.57769573 |
| Kurtosis | -1.2002091 |
| Mean | 5.0010035 × 1012 |
| Median Absolute Deviation (MAD) | 2.5010961 × 1012 |
| Skewness | -0.00099756212 |
| Sum | 1.3466202 × 1018 |
| Variance | 8.3466581 × 1024 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.067741336 × 1012 | 19 | < 0.1% |
| 5.450729213 × 1012 | 12 | < 0.1% |
| 5.674512345 × 1012 | 12 | < 0.1% |
| 1.438908826 × 1012 | 12 | < 0.1% |
| 6.006171343 × 1012 | 12 | < 0.1% |
| 7.200775697 × 1012 | 12 | < 0.1% |
| 9.554701198 × 1012 | 12 | < 0.1% |
| 6.907628391 × 1011 | 12 | < 0.1% |
| 4.302833979 × 1012 | 12 | < 0.1% |
| 3.424880772 × 1011 | 12 | < 0.1% |
| Other values (147168) | 269143 | |
| (Missing) | 9317 | 3.3% |
| Value | Count | Frequency (%) |
| 135149629 | 1 | |
| 175591785 | 1 | |
| 213976710 | 1 | |
| 402685065 | 2 | |
| 479960157 | 1 | |
| 497546968 | 1 | |
| 523138549 | 1 | |
| 553233603 | 1 | |
| 655018917 | 1 | |
| 690112892 | 1 |
| Value | Count | Frequency (%) |
| 9.999937663 × 1012 | 1 | |
| 9.999858228 × 1012 | 1 | |
| 9.999853088 × 1012 | 1 | |
| 9.999796206 × 1012 | 1 | |
| 9.999718983 × 1012 | 1 | |
| 9.999698537 × 1012 | 1 | |
| 9.999620617 × 1012 | 1 | |
| 9.999465428 × 1012 | 1 | |
| 9.999380799 × 1012 | 1 | |
| 9.99926455 × 1012 | 1 |
RECEIVER
Text
| Distinct | 5008 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 16.102833 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4486040 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1625 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | SOLAR TURBINES |
|---|---|
| 2nd row | SOLAR TURBINES KEARN |
| 3rd row | TURBOTEC SOLAR TURBI |
| 4th row | SOLAR TURBINES KEARN |
| 5th row | SOLAR TURBINES KEARN |
| Value | Count | Frequency (%) |
| solar | 182693 | |
| turbines | 175915 | |
| harbo | 42502 | 6.2% |
| kearn | 27383 | 4.0% |
| inc | 14444 | 2.1% |
| overh | 12819 | 1.9% |
| turbotec | 9780 | 1.4% |
| c/o | 7707 | 1.1% |
| ups-scs | 7675 | 1.1% |
| reman | 6555 | 1.0% |
| Other values (4390) | 197536 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 567649 | |
| S | 438447 | |
| 406555 | ||
| A | 359775 | 8.0% |
| O | 340462 | 7.6% |
| E | 330377 | 7.4% |
| N | 292475 | 6.5% |
| I | 274393 | 6.1% |
| T | 264994 | 5.9% |
| B | 254506 | 5.7% |
| Other values (37) | 956407 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4058404 | |
| Space Separator | 406555 | 9.1% |
| Dash Punctuation | 10931 | 0.2% |
| Other Punctuation | 9503 | 0.2% |
| Decimal Number | 624 | < 0.1% |
| Open Punctuation | 22 | < 0.1% |
| Modifier Symbol | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 567649 | |
| S | 438447 | |
| A | 359775 | |
| O | 340462 | |
| E | 330377 | |
| N | 292475 | |
| I | 274393 | 6.8% |
| T | 264994 | 6.5% |
| B | 254506 | 6.3% |
| L | 243451 | 6.0% |
| Other values (16) | 691875 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 232 | |
| 3 | 162 | |
| 0 | 64 | 10.3% |
| 1 | 54 | 8.7% |
| 8 | 35 | 5.6% |
| 6 | 27 | 4.3% |
| 4 | 21 | 3.4% |
| 5 | 20 | 3.2% |
| 9 | 5 | 0.8% |
| 7 | 4 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 8109 | |
| & | 737 | 7.8% |
| % | 638 | 6.7% |
| . | 13 | 0.1% |
| ' | 3 | < 0.1% |
| ; | 3 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 15 | |
| [ | 7 |
Space Separator
| Value | Count | Frequency (%) |
| 406555 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10931 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4058404 | |
| Common | 427636 | 9.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 567649 | |
| S | 438447 | |
| A | 359775 | |
| O | 340462 | |
| E | 330377 | |
| N | 292475 | |
| I | 274393 | 6.8% |
| T | 264994 | 6.5% |
| B | 254506 | 6.3% |
| L | 243451 | 6.0% |
| Other values (16) | 691875 |
Common
| Value | Count | Frequency (%) |
| 406555 | ||
| - | 10931 | 2.6% |
| / | 8109 | 1.9% |
| & | 737 | 0.2% |
| % | 638 | 0.1% |
| 2 | 232 | 0.1% |
| 3 | 162 | < 0.1% |
| 0 | 64 | < 0.1% |
| 1 | 54 | < 0.1% |
| 8 | 35 | < 0.1% |
| Other values (11) | 119 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4486040 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 567649 | |
| S | 438447 | |
| 406555 | ||
| A | 359775 | 8.0% |
| O | 340462 | 7.6% |
| E | 330377 | 7.4% |
| N | 292475 | 6.5% |
| I | 274393 | 6.1% |
| T | 264994 | 5.9% |
| B | 254506 | 5.7% |
| Other values (37) | 956407 |
SHIPPER
Text
| Distinct | 5101 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 2.1 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 28 |
| Mean length | 16.400386 |
| Min length | 2 |
Characters and Unicode
| Total characters | 4568918 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1701 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | WYMAN GORDON |
|---|---|
| 2nd row | ROSEMOUNT INC |
| 3rd row | PPG INDUSTRIES |
| 4th row | REGAL BELOIT |
| 5th row | REGAL BELOIT |
| Value | Count | Frequency (%) |
| solar | 113143 | 16.2% |
| turbines | 112488 | 16.2% |
| inc | 42884 | 6.2% |
| overhaul | 23152 | 3.3% |
| turbotec | 22165 | 3.2% |
| turbo | 14594 | 2.1% |
| tecnologi | 14189 | 2.0% |
| mesa | 12853 | 1.8% |
| kearny | 12802 | 1.8% |
| drive | 11951 | 1.7% |
| Other values (4449) | 316056 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 484667 | |
| 417909 | 9.1% | |
| E | 359138 | 7.9% |
| S | 342833 | 7.5% |
| O | 341627 | 7.5% |
| A | 340089 | 7.4% |
| I | 297961 | 6.5% |
| T | 293624 | 6.4% |
| N | 291025 | 6.4% |
| L | 243436 | 5.3% |
| Other values (48) | 1156609 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4123779 | |
| Space Separator | 417909 | 9.1% |
| Dash Punctuation | 13468 | 0.3% |
| Other Punctuation | 13212 | 0.3% |
| Decimal Number | 273 | < 0.1% |
| Lowercase Letter | 198 | < 0.1% |
| Open Punctuation | 43 | < 0.1% |
| Close Punctuation | 36 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 484667 | |
| E | 359138 | 8.7% |
| S | 342833 | 8.3% |
| O | 341627 | 8.3% |
| A | 340089 | 8.2% |
| I | 297961 | 7.2% |
| T | 293624 | 7.1% |
| N | 291025 | 7.1% |
| L | 243436 | 5.9% |
| U | 229768 | 5.6% |
| Other values (16) | 899611 |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 28 | |
| a | 28 | |
| n | 28 | |
| l | 16 | |
| o | 14 | |
| j | 14 | |
| c | 14 | |
| m | 14 | |
| d | 14 | |
| r | 14 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 110 | |
| 2 | 36 | 13.2% |
| 1 | 36 | 13.2% |
| 3 | 35 | 12.8% |
| 6 | 15 | 5.5% |
| 4 | 13 | 4.8% |
| 5 | 12 | 4.4% |
| 8 | 6 | 2.2% |
| 9 | 5 | 1.8% |
| 7 | 5 | 1.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 10984 | |
| & | 1503 | 11.4% |
| . | 421 | 3.2% |
| % | 281 | 2.1% |
| , | 12 | 0.1% |
| ' | 6 | < 0.1% |
| ; | 5 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 417909 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13468 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 43 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 36 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4123977 | |
| Common | 444941 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 484667 | |
| E | 359138 | 8.7% |
| S | 342833 | 8.3% |
| O | 341627 | 8.3% |
| A | 340089 | 8.2% |
| I | 297961 | 7.2% |
| T | 293624 | 7.1% |
| N | 291025 | 7.1% |
| L | 243436 | 5.9% |
| U | 229768 | 5.6% |
| Other values (27) | 899809 |
Common
| Value | Count | Frequency (%) |
| 417909 | ||
| - | 13468 | 3.0% |
| / | 10984 | 2.5% |
| & | 1503 | 0.3% |
| . | 421 | 0.1% |
| % | 281 | 0.1% |
| 0 | 110 | < 0.1% |
| ( | 43 | < 0.1% |
| ) | 36 | < 0.1% |
| 2 | 36 | < 0.1% |
| Other values (11) | 150 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4568918 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 484667 | |
| 417909 | 9.1% | |
| E | 359138 | 7.9% |
| S | 342833 | 7.5% |
| O | 341627 | 7.5% |
| A | 340089 | 7.4% |
| I | 297961 | 6.5% |
| T | 293624 | 6.4% |
| N | 291025 | 6.4% |
| L | 243436 | 5.3% |
| Other values (48) | 1156609 |
SHIPPER_NAME
Categorical
IMBALANCE 
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| SOLAR TURBINES - SAN DIEGO | |
|---|---|
| SOLAR TURBINES - DESOTO | |
| SOLAR TURBINES-FAIRBURN | |
| SOLAR TURBINES - MABANK | 12972 |
| SOLAR TURBINES-AIR SAN DIEGO | 7240 |
| Other values (14) | 15227 |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 25.249348 |
| Min length | 23 |
Characters and Unicode
| Total characters | 7034140 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SOLAR TURBINES - SAN DIEGO |
|---|---|
| 2nd row | SOLAR TURBINES - SAN DIEGO |
| 3rd row | SOLAR TURBINES - SAN DIEGO |
| 4th row | SOLAR TURBINES - SAN DIEGO |
| 5th row | SOLAR TURBINES - SAN DIEGO |
Common Values
| Value | Count | Frequency (%) |
| SOLAR TURBINES - SAN DIEGO | 184939 | |
| SOLAR TURBINES - DESOTO | 34444 | 12.4% |
| SOLAR TURBINES-FAIRBURN | 23765 | 8.5% |
| SOLAR TURBINES - MABANK | 12972 | 4.7% |
| SOLAR TURBINES-AIR SAN DIEGO | 7240 | 2.6% |
| SOLAR TURBINES-TURBO FAB | 4466 | 1.6% |
| SOLAR TURBINES-HARBOR DRIVE | 3431 | 1.2% |
| SOLAR TURBINES-TURBOTEC | 2793 | 1.0% |
| SOLAR TURBINES-AIR FAIRBURN | 2691 | 1.0% |
| SOLAR TURBINES-KEARNY MESA | 786 | 0.3% |
| Other values (9) | 1060 | 0.4% |
Length
| Value | Count | Frequency (%) |
| solar | 278587 | |
| 232355 | ||
| turbines | 232355 | |
| san | 192179 | |
| diego | 192179 | |
| desoto | 34628 | 2.8% |
| turbines-fairburn | 23765 | 1.9% |
| mabank | 13113 | 1.1% |
| turbines-air | 10640 | 0.9% |
| turbines-turbo | 4466 | 0.4% |
| Other values (20) | 19854 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 955534 | ||
| S | 784977 | |
| R | 641073 | |
| O | 551638 | |
| A | 544294 | 7.7% |
| E | 513883 | 7.3% |
| I | 511445 | 7.3% |
| N | 511428 | 7.3% |
| B | 333837 | 4.7% |
| T | 323315 | 4.6% |
| Other values (14) | 1362716 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5800019 | |
| Space Separator | 955534 | 13.6% |
| Dash Punctuation | 278587 | 4.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 784977 | |
| R | 641073 | |
| O | 551638 | |
| A | 544294 | |
| E | 513883 | |
| I | 511445 | |
| N | 511428 | |
| B | 333837 | |
| T | 323315 | |
| U | 312478 | 5.4% |
| Other values (12) | 771651 |
Space Separator
| Value | Count | Frequency (%) |
| 955534 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 278587 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5800019 | |
| Common | 1234121 | 17.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 784977 | |
| R | 641073 | |
| O | 551638 | |
| A | 544294 | |
| E | 513883 | |
| I | 511445 | |
| N | 511428 | |
| B | 333837 | |
| T | 323315 | |
| U | 312478 | 5.4% |
| Other values (12) | 771651 |
Common
| Value | Count | Frequency (%) |
| 955534 | ||
| - | 278587 | 22.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7034140 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 955534 | ||
| S | 784977 | |
| R | 641073 | |
| O | 551638 | |
| A | 544294 | 7.7% |
| E | 513883 | 7.3% |
| I | 511445 | 7.3% |
| N | 511428 | 7.3% |
| B | 333837 | 4.7% |
| T | 323315 | 4.6% |
| Other values (14) | 1362716 |
SHIP_DATE
Date
| Distinct | 1466 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2024-02-02 00:00:00 |
SHIP_WEIGHT
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 13633 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3400.4959 |
| Minimum | 0 |
|---|---|
| Maximum | 1421500 |
| Zeros | 51581 |
| Zeros (%) | 18.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 95 |
| median | 401.234 |
| Q3 | 1492.504 |
| 95-th percentile | 17815 |
| Maximum | 1421500 |
| Range | 1421500 |
| Interquartile range (IQR) | 1397.504 |
Descriptive statistics
| Standard deviation | 15863.319 |
|---|---|
| Coefficient of variation (CV) | 4.6650017 |
| Kurtosis | 1291.2691 |
| Mean | 3400.4959 |
| Median Absolute Deviation (MAD) | 401.234 |
| Skewness | 25.842011 |
| Sum | 9.4733395 × 108 |
| Variance | 2.516449 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 51581 | 18.5% |
| 1 | 2559 | 0.9% |
| 2.205 | 1937 | 0.7% |
| 100 | 1235 | 0.4% |
| 200 | 1106 | 0.4% |
| 300 | 1094 | 0.4% |
| 150 | 1021 | 0.4% |
| 400 | 965 | 0.3% |
| 1500 | 938 | 0.3% |
| 500 | 903 | 0.3% |
| Other values (13623) | 215248 |
| Value | Count | Frequency (%) |
| 0 | 51581 | |
| 1 | 2559 | 0.9% |
| 2 | 145 | 0.1% |
| 2.205 | 1937 | 0.7% |
| 3 | 88 | < 0.1% |
| 4 | 128 | < 0.1% |
| 4.409 | 563 | 0.2% |
| 5 | 132 | < 0.1% |
| 6 | 51 | < 0.1% |
| 6.614 | 322 | 0.1% |
| Value | Count | Frequency (%) |
| 1421500 | 1 | < 0.1% |
| 1158465.326 | 6 | |
| 973639 | 2 | < 0.1% |
| 971503.29 | 1 | < 0.1% |
| 672356.538 | 4 | |
| 663641.813 | 5 | |
| 532968 | 3 | < 0.1% |
| 527277.208 | 2 | < 0.1% |
| 500683.299 | 9 | |
| 454129.078 | 5 |
SOLAR_MODE
Categorical
HIGH CORRELATION 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 234 |
| Missing (%) | 0.1% |
| Memory size | 2.1 MiB |
| LTL | |
|---|---|
| AE | |
| TL | |
| FF | |
| CU | |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.4519154 |
| Min length | 2 |
Characters and Unicode
| Total characters | 682498 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LTL |
|---|---|
| 2nd row | LTL |
| 3rd row | LTL |
| 4th row | LTL |
| 5th row | LTL |
Common Values
| Value | Count | Frequency (%) |
| LTL | 119510 | |
| AE | 71562 | |
| TL | 26326 | 9.4% |
| FF | 22269 | 8.0% |
| CU | 22231 | 8.0% |
| HH | 6998 | 2.5% |
| OCN | 6251 | 2.2% |
| CR | 2939 | 1.1% |
| PA | 164 | 0.1% |
| MV | 40 | < 0.1% |
| Other values (2) | 63 | < 0.1% |
| (Missing) | 234 | 0.1% |
Length
| Value | Count | Frequency (%) |
| ltl | 119510 | |
| ae | 71562 | |
| tl | 26326 | 9.5% |
| ff | 22269 | 8.0% |
| cu | 22231 | 8.0% |
| hh | 6998 | 2.5% |
| ocn | 6251 | 2.2% |
| cr | 2939 | 1.1% |
| pa | 164 | 0.1% |
| mv | 40 | < 0.1% |
| Other values (2) | 63 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 265346 | |
| T | 145836 | |
| A | 71757 | 10.5% |
| E | 71562 | 10.5% |
| F | 44538 | 6.5% |
| C | 31421 | 4.6% |
| U | 22231 | 3.3% |
| H | 13996 | 2.1% |
| O | 6251 | 0.9% |
| N | 6251 | 0.9% |
| Other values (5) | 3309 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 682498 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 265346 | |
| T | 145836 | |
| A | 71757 | 10.5% |
| E | 71562 | 10.5% |
| F | 44538 | 6.5% |
| C | 31421 | 4.6% |
| U | 22231 | 3.3% |
| H | 13996 | 2.1% |
| O | 6251 | 0.9% |
| N | 6251 | 0.9% |
| Other values (5) | 3309 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 682498 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 265346 | |
| T | 145836 | |
| A | 71757 | 10.5% |
| E | 71562 | 10.5% |
| F | 44538 | 6.5% |
| C | 31421 | 4.6% |
| U | 22231 | 3.3% |
| H | 13996 | 2.1% |
| O | 6251 | 0.9% |
| N | 6251 | 0.9% |
| Other values (5) | 3309 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 682498 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 265346 | |
| T | 145836 | |
| A | 71757 | 10.5% |
| E | 71562 | 10.5% |
| F | 44538 | 6.5% |
| C | 31421 | 4.6% |
| U | 22231 | 3.3% |
| H | 13996 | 2.1% |
| O | 6251 | 0.9% |
| N | 6251 | 0.9% |
| Other values (5) | 3309 | 0.5% |
| ACCESSORIAL_AMOUNT | ACCESSORIAL_CHARGE_AMOUNT | AMOUNT_PAID | BILL_TYPE | CARRIER_MODE_DESCRIPTION | IO_CODE | IO_CODE_DESCRIPTION | MILEAGE | PRO_NUMBER2 | SHIPPER_NAME | SHIP_WEIGHT | SOLAR_MODE | Unnamed: 0 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACCESSORIAL_AMOUNT | 1.000 | 0.600 | 0.890 | 0.048 | 0.006 | 0.017 | 0.017 | -0.475 | -0.005 | 0.000 | 0.012 | 0.053 | 0.056 |
| ACCESSORIAL_CHARGE_AMOUNT | 0.600 | 1.000 | 0.576 | 0.090 | 0.013 | 0.014 | 0.014 | -0.036 | -0.001 | 0.011 | 0.216 | 0.064 | 0.050 |
| AMOUNT_PAID | 0.890 | 0.576 | 1.000 | 0.027 | 0.017 | 0.022 | 0.022 | -0.294 | -0.002 | 0.014 | 0.285 | 0.057 | 0.088 |
| BILL_TYPE | 0.048 | 0.090 | 0.027 | 1.000 | 0.035 | 0.250 | 0.250 | 0.416 | 0.007 | 0.262 | 0.599 | 0.515 | 0.164 |
| CARRIER_MODE_DESCRIPTION | 0.006 | 0.013 | 0.017 | 0.035 | 1.000 | 0.153 | 0.153 | 0.256 | -0.001 | 0.343 | 0.084 | 0.415 | -0.145 |
| IO_CODE | 0.017 | 0.014 | 0.022 | 0.250 | 0.153 | 1.000 | 1.000 | -0.053 | -0.003 | 0.274 | 0.039 | 0.399 | 0.824 |
| IO_CODE_DESCRIPTION | 0.017 | 0.014 | 0.022 | 0.250 | 0.153 | 1.000 | 1.000 | -0.064 | -0.003 | 0.274 | 0.095 | 0.399 | 0.943 |
| MILEAGE | -0.475 | -0.036 | -0.294 | 0.416 | 0.256 | -0.053 | -0.064 | 1.000 | 0.008 | 0.161 | 0.365 | 0.193 | -0.078 |
| PRO_NUMBER2 | -0.005 | -0.001 | -0.002 | 0.007 | -0.001 | -0.003 | -0.003 | 0.008 | 1.000 | 0.010 | 0.002 | 0.010 | -0.003 |
| SHIPPER_NAME | 0.000 | 0.011 | 0.014 | 0.262 | 0.343 | 0.274 | 0.274 | 0.161 | 0.010 | 1.000 | -0.067 | 0.177 | -0.051 |
| SHIP_WEIGHT | 0.012 | 0.216 | 0.285 | 0.599 | 0.084 | 0.039 | 0.095 | 0.365 | 0.002 | -0.067 | 1.000 | 0.064 | 0.068 |
| SOLAR_MODE | 0.053 | 0.064 | 0.057 | 0.515 | 0.415 | 0.399 | 0.399 | 0.193 | 0.010 | 0.177 | 0.064 | 1.000 | -0.112 |
| Unnamed: 0 | 0.056 | 0.050 | 0.088 | 0.164 | -0.145 | 0.824 | 0.943 | -0.078 | -0.003 | -0.051 | 0.068 | -0.112 | 1.000 |
| Unnamed: 0 | ACCESSORIAL_AMOUNT | ACCESSORIAL_CHARGE_AMOUNT | ACCESSORIAL_CHARGE_CODE | ACCESSORIAL_CHARGE_DESCRIPTION | AMOUNT_PAID | BILL_DATE | BILL_TYPE | CARRIER_MODE_DESCRIPTION | CARRIER_NAME2 | DESTINATION_CITY | DESTINATION_COUNTRY_CODE | DESTINATION_NAME2 | DESTINATION_STATE | DESTINATION_ZIP | IO_CODE | IO_CODE_DESCRIPTION | MILEAGE | ORIGIN_CITY | ORIGIN_COUNTRY_CODE | ORIGIN_NAME2 | ORIGIN_STATE | ORIGIN_ZIP | PROCESS_DATE | PRO_NUMBER2 | RECEIVER | SHIPPER | SHIPPER_NAME | SHIP_DATE | SHIP_WEIGHT | SOLAR_MODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 116.23644 | 116.23644 | FS | FUEL SURCHARGE | 784.27404 | 2021-09-28 | LINEHAUL | MOTOR | Young Ltd | BROKEN ARROW | US | Christopher Shepard | OK | 74012 | 1 | Inbound | 1237 | MOUNTAIN TOP | US | Derrick Castro | PA | 18707 | 2021-10-12 | 3.186389e+12 | SOLAR TURBINES | WYMAN GORDON | SOLAR TURBINES - SAN DIEGO | 2021-09-28 | 2830.0 | LTL |
| 1 | 1 | 32.77116 | 32.77116 | FS | FUEL SURCHARGE | 221.09364 | 2021-09-24 | LINEHAUL | MOTOR | Young Ltd | SAN DIEGO | US | Ashley Cruz | CA | 92123 | 1 | Inbound | 1899 | SHAKOPEE | US | Jason Harvey | MN | 55379 | 2021-10-12 | 7.564392e+12 | SOLAR TURBINES KEARN | ROSEMOUNT INC | SOLAR TURBINES - SAN DIEGO | 2021-09-24 | 549.0 | LTL |
| 2 | 2 | 48.34206 | 38.48706 | FS | FUEL SURCHARGE | 268.29252 | 2021-10-08 | LINEHAUL | MOTOR | Young Ltd | SAN DIEGO | US | Jeremy Colon | CA | 92154 | 1 | Inbound | 1640 | ALEXANDER | US | Julia Nielsen | AR | 72002 | 2021-10-19 | 3.416653e+12 | TURBOTEC SOLAR TURBI | PPG INDUSTRIES | SOLAR TURBINES - SAN DIEGO | 2021-10-08 | 688.0 | LTL |
| 3 | 3 | 22.25916 | 22.25916 | FS | FUEL SURCHARGE | 151.68816 | 2021-09-08 | LINEHAUL | MOTOR | Young Ltd | SAN DIEGO | US | Ashley Cruz | CA | 92123 | 1 | Inbound | 2166 | FLORENCE | US | Richard Wright | KY | 41042 | 2021-10-12 | 5.769524e+12 | SOLAR TURBINES KEARN | REGAL BELOIT | SOLAR TURBINES - SAN DIEGO | 2021-09-08 | 220.0 | LTL |
| 4 | 4 | 22.52196 | 22.52196 | FS | FUEL SURCHARGE | 151.95096 | 2021-09-24 | LINEHAUL | MOTOR | Young Ltd | SAN DIEGO | US | Ashley Cruz | CA | 92123 | 1 | Inbound | 2166 | FLORENCE | US | Richard Wright | KY | 41042 | 2021-10-12 | 5.837051e+12 | SOLAR TURBINES KEARN | REGAL BELOIT | SOLAR TURBINES - SAN DIEGO | 2021-09-24 | 252.0 | LTL |
| 5 | 5 | 25.37334 | 25.37334 | FS | FUEL SURCHARGE | 171.22734 | 2021-09-30 | LINEHAUL | MOTOR | Young Ltd | FAIRBURN | US | Michael Clark | GA | 30213 | 1 | Inbound | 444 | FLORENCE | US | Richard Wright | KY | 41042 | 2021-10-12 | 7.619189e+12 | SOLAR TURBINES INC | REGAL BELOIT | SOLAR TURBINES - SAN DIEGO | 2021-09-30 | 640.0 | LTL |
| 6 | 6 | 23.82282 | 23.82282 | FS | FUEL SURCHARGE | 160.72848 | 2021-09-28 | LINEHAUL | MOTOR | Young Ltd | FAIRBURN | US | Michael Clark | GA | 30213 | 1 | Inbound | 2118 | SAN DIEGO | US | Roy Sanchez | CA | 92154 | 2021-10-12 | 3.652718e+12 | SOLAR TURBINES INC | SOLAR TURBINES | SOLAR TURBINES - SAN DIEGO | 2021-09-28 | 305.0 | LTL |
| 7 | 7 | 22.65336 | 22.65336 | FS | FUEL SURCHARGE | 152.08236 | 2021-10-05 | LINEHAUL | MOTOR | Young Ltd | BROKEN ARROW | US | Christopher Shepard | OK | 74012 | 1 | Inbound | 759 | WAUKESHA | US | Robert James | WI | 53186 | 2021-10-19 | 4.614602e+12 | SOLAR TURBINES | METAL TEK | SOLAR TURBINES - SAN DIEGO | 2021-10-05 | 300.0 | LTL |
| 8 | 8 | 130.26996 | 130.26996 | FS | FUEL SURCHARGE | 874.67724 | 2021-10-04 | LINEHAUL | MOTOR | Young Ltd | BROKEN ARROW | US | Christopher Shepard | OK | 74012 | 1 | Inbound | 971 | YORK | US | Melissa Hayes | SC | 29745 | 2021-10-19 | 3.399017e+12 | SOLAR TURBINES | FOMAS INC | SOLAR TURBINES - SAN DIEGO | 2021-10-04 | 3750.0 | LTL |
| 9 | 9 | 21.27366 | 21.27366 | FS | FUEL SURCHARGE | 142.81866 | 2021-10-06 | LINEHAUL | MOTOR | Young Ltd | FAIRBURN | US | Michael Clark | GA | 30213 | 1 | Inbound | 266 | GREENEVILLE | US | Wayne Martin | TN | 37743 | 2021-10-19 | 6.518610e+12 | SOLAR TURBINES INC | DONALDSON CO IN | SOLAR TURBINES - SAN DIEGO | 2021-10-06 | 1044.0 | LTL |
| Unnamed: 0 | ACCESSORIAL_AMOUNT | ACCESSORIAL_CHARGE_AMOUNT | ACCESSORIAL_CHARGE_CODE | ACCESSORIAL_CHARGE_DESCRIPTION | AMOUNT_PAID | BILL_DATE | BILL_TYPE | CARRIER_MODE_DESCRIPTION | CARRIER_NAME2 | DESTINATION_CITY | DESTINATION_COUNTRY_CODE | DESTINATION_NAME2 | DESTINATION_STATE | DESTINATION_ZIP | IO_CODE | IO_CODE_DESCRIPTION | MILEAGE | ORIGIN_CITY | ORIGIN_COUNTRY_CODE | ORIGIN_NAME2 | ORIGIN_STATE | ORIGIN_ZIP | PROCESS_DATE | PRO_NUMBER2 | RECEIVER | SHIPPER | SHIPPER_NAME | SHIP_DATE | SHIP_WEIGHT | SOLAR_MODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278577 | 278577 | 43.30944 | 43.30944 | FS | FUEL SURCHARGE | 309.03966 | 2021-04-08 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | TULSA | US | Jose Harvey | OK | 74117 | 4 | Third Party | 672 | SHAKOPEE | US | Pamela Dominguez | MN | 55379 | 2021-04-26 | NaN | BERENDSEN FLUID | CONTINENTAL HYD | SOLAR TURBINES - SAN DIEGO | 2021-04-08 | 1660.0 | LTL |
| 278578 | 278578 | 34.13772 | 34.13772 | FS | FUEL SURCHARGE | 243.57618 | 2021-04-05 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | CARSON | US | Donna Lee | CA | 90745 | 4 | Third Party | 2603 | HONEOYE FALLS | US | Michael Young | NY | 14472 | 2021-04-26 | NaN | CAL-COAST PACKI | GRAVER TECHNOLO | SOLAR TURBINES - SAN DIEGO | 2021-04-05 | 742.0 | LTL |
| 278579 | 278579 | 60.98274 | 60.98274 | FS | FUEL SURCHARGE | 437.45688 | 2021-04-13 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | ROCKFORD | US | Vanessa Blair | IL | 61104 | 4 | Third Party | 967 | CORSICANA | US | Tina Pierce | TX | 75110 | 2021-04-27 | NaN | DIAL MACHINE | OIL CITY IRON W | SOLAR TURBINES - SAN DIEGO | 2021-04-13 | 2505.0 | LTL |
| 278580 | 278580 | 15.13728 | 15.13728 | FS | FUEL SURCHARGE | 108.03708 | 2021-04-09 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | PHOENIX | US | Kathleen Fields | AZ | 85040 | 4 | Third Party | 352 | SAN DIEGO | US | Richard Davis | CA | 92154 | 2021-04-26 | NaN | CHROMALLOY ARIZ | CHROMALLOY PGTC | SOLAR TURBINES - SAN DIEGO | 2021-04-09 | 150.0 | LTL |
| 278581 | 278581 | 57.13272 | 57.13272 | FS | FUEL SURCHARGE | 407.66850 | 2021-04-07 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | FOUNTAIN VALLEY | US | Javier Harrington | CA | 92708 | 4 | Third Party | 1423 | CORSICANA | US | Tina Pierce | TX | 75110 | 2021-04-27 | NaN | OMNI METAL FINI | OIL CITY IRON W | SOLAR TURBINES - SAN DIEGO | 2021-04-07 | 1973.0 | LTL |
| 278582 | 278582 | 15.61032 | 15.61032 | FS | FUEL SURCHARGE | 111.40092 | 2021-04-07 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | ESCONDIDO | US | Patricia Lloyd | CA | 92029 | 4 | Third Party | 1401 | CORSICANA | US | Tina Pierce | TX | 75110 | 2021-04-27 | NaN | PRICE PRODUCTS | OIL CITY IRON W | SOLAR TURBINES - SAN DIEGO | 2021-04-07 | 299.0 | LTL |
| 278583 | 278583 | 16.25418 | 16.25418 | FS | FUEL SURCHARGE | 116.55180 | 2021-04-12 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | PHOENIX | US | Kathleen Fields | AZ | 85040 | 4 | Third Party | 352 | SAN DIEGO | US | Heather Miles | CA | 92154 | 2021-04-27 | NaN | CHROMALLOY ARIZ | UPS SUPPLY CHAI | SOLAR TURBINES - SAN DIEGO | 2021-04-12 | 114.0 | LTL |
| 278584 | 278584 | 15.99138 | 15.99138 | FS | FUEL SURCHARGE | 114.68592 | 2021-04-13 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | SAN MARCOS | US | Barbara Richards | CA | 92069 | 4 | Third Party | 36 | SAN DIEGO | US | Heather Miles | CA | 92154 | 2021-04-27 | NaN | BLACK OXIDE SER | UPS SUPPLY CHAI | SOLAR TURBINES - SAN DIEGO | 2021-04-13 | 268.0 | LTL |
| 278585 | 278585 | 40.95738 | 15.99138 | FS | FUEL SURCHARGE | 139.65192 | 2021-04-13 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | HUNTINGTON PARK | US | Erika Stark | CA | 90255 | 4 | Third Party | 120 | SAN DIEGO | US | Heather Miles | CA | 92154 | 2021-04-27 | NaN | BODYCOTE THERMA | UPS SUPPLY CHAI | SOLAR TURBINES - SAN DIEGO | 2021-04-13 | 205.0 | LTL |
| 278586 | 278586 | 74.22786 | 74.22786 | FS | FUEL SURCHARGE | 529.59456 | 2021-04-08 | LINEHAUL | MOTOR | Hodges, Lyons and Weaver | CARROLLTON | US | Nicole Banks | TX | 75006 | 4 | Third Party | 1633 | NORTH HAVEN | US | Grant Harper | CT | 6473 | 2021-04-27 | NaN | AMERICAN CRATIN | SAFT AMERICA | SOLAR TURBINES - SAN DIEGO | 2021-04-08 | 1865.0 | LTL |